User's Guide User's Guide User's Guide i i i GOVERNMENT SPENDING USER'S GUIDE CD Publising, Inc. February 1994 User's Guide User's Guide User's Guide ii ii ii IMPORTANT Information contained on this disc is subject to change without notice and does not represent a commitment on the part of CD Publishing, Inc. The software and data are furnished under the license agreement stated in this document. The software used to display menuing and search/retrieval may be used and copied only under the terms of this agreement. The purchaser may make one copy of this software for backup purposes. Copyrights and Trademarks Government Spending 1.0 is a trademark of CD Publishing, Inc. The CDPMenu 1.0 software is the licensed property of CD Publishing, Inc. and is copyrighted 1994 by CD Publishing, Inc. All rights reserved. Government Spending 1.0 User's Guide, copyrighted 1994 by CD Publishing, Inc. IBM and AT are registered trademarks, and PC and PC/XT are registered trademarks of International Business Machines Corporation. GEnie is a registered trademark of General Electric Information Services. CompuServe is a registered trademark of CompuServe. Microsoft, Microsoft Extensions CD, and Microsoft Windows are registered trademarks of Microsoft Corporation. HP, Laserjet, and Deskjet are registered trademarks of Hewlett Packard Company. Cover art copyrighted New Vision Technologies, Inc. The Government Spending User's Guide , software or portions thereof may not be reproduced in any form whatsoever (except as permitted within the license agreement) without the written permission of CD Publishing, Inc. Correspondence concerning the Government Spending disc and documentation should be directed to CD Publishing, Inc., 4960 Wolf Creek Trail, Flower Mound, TX. 75028-1954. Printed February 1994 in the USA. *********************************************** License CD Publishing, Inc. hereby grants you a license to use the CD-ROM and the CDP software in accordance with the terms and conditions set forth in this Agreement. User's Guide User's Guide User's Guide iii iii iii The CDP Software may not be copied and may only be loaded onto a single computer at any given time. The CDP Software many not be placed on a local area network unless you have a separate network license from CD Publishing, Inc. Notwithstanding your ownership of the physical media on which the software is stored, this Agreement does not grant you any ownership interest in or to the software itself. You may transfer this license to any subsequent purchaser of the physical CD-ROM, provided you notify CD Publishing, Inc. in writing. User's Guide User's Guide User's Guide iv iv iv Limited Warranty CD Publishing, Inc. warrants the physical CD-ROM and accompanying documentation to be free from defects in material and workmanship for a period of sixty (60) days from date of purchase (the "Warranty Period"). CD Publishing, Inc. will replace this CD-ROM , if defective, provided that it is returned, postage prepaid, to CD Publishing, Inc. within the Warranty Period and CD Publishing, Inc. confirms that the defect existed at the time you purchased it and was not caused by misuse or abuse. CD Publishing's entire liability to you, and your exclusive remedy for breach of this Limited Warranty shall be limited to replacement of defective CD-ROM(s) or documentation and shall not include or extend to claim for or right to recover any other damages, including but not limited to, loss of profit, data, or use of the software, or special incidental, or consequential damages or other claims, even if CDP has been specifically advised of the possibility of such damages. In no event will CDP's liability for any damages to you or any other person ever exceed the lower of suggested list price or actual price you paid for the license to use the software, regardless of the form of the claim. THE FOREGOING LIMITED WARRANTY IS IN LIEU OF ALL OTHER WARRANTIES, AND CD PUBLISHING EXPRESSLY DISCLAIMS ALL OTHER WARRANTIES, EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, ANY IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. This limited warranty gives you specific legal rights. You may have other legal rights that may vary from state to state. Some states do not allow the exclusion of incidental or consequential damages, or the limitation on how long an implied warranty lasts, so some of the above may not apply. Governing Law and General Provisions This Agreement shall be construed, interpreted, and governed by the laws of the State of Texas. If any provision of this Agreement is found void or unenforceable, it will not affect the validity of the balance of this Agreement, which shall remain valid and enforceable according to it's terms. If any remedy provided is determined to have failed of it's essential purpose, all limitations of liability and exclusions of damages set forth in the Limited Warranty shall remain in full force and effect. This Agreement may only be modified in writing signed by you and an authorized officer of CD Publishing. Use, duplication, or disclosure by the U.S. Government of the computer software and documentation in this package shall be subject to the restricted rights applicable to commercial computer software (under DFARS 52.227-7013). All rights not specifically granted in this Agreement are reserved by CD Publishing, Inc. Mail Order Refund Policy User's Guide User's Guide User's Guide v v v For mail order sales using credit cards, purchaser may return the product(s) in it's original condition within 15 days of purchase for full refund of the CD-ROM cost, less shipping and handling charges. If return is necessary, purchaser must include written statement with returned merchandise stating they have not copied or used any portion of the software or data contained on the disc. User's Guide User's Guide User's Guide vi vi vi User's Guide User's Guide User's Guide vii vii vii Preface CD Publishing, Inc. is proud to present Government Spending. The Office of Federal Procurement Policy Act required the establishment of a computer database for collecting, developing, and disseminating data to Congress, the executive branch, and to the private sector. This disc represents a collection of data on purchases by the federal government. Over 63 agencies are represented in this data covering 61 States and outlying areas plus multiple foreign countries. Our intent of distributing this data to the private sector was to assist businesses in recognizing opportunities for future sales and to provide others with a better understanding of how our federal government is spending our money. Although this data represents prior sales, we feel you can learn significant information about government buying habits and competitive bidding by viewing past records. CD Publishing, Inc. does not guarantee the accuracy of any of the data distributed on this disc. As with all data, errors in recording, filing, and retrieval are possible. This disc does not represent all purchases made by the federal government. It does represent the data the Federal Procurement Data Center collects and reports. If you have any comments please send us a letter. We consider all suggestions as we strive to maintain the highest level of quality products and services, at reasonable prices. Thank you for your support of CD Publishing, Inc. Sincerely, Larry Nelson President CD Publishing, Inc. 4960 Wolf Creek Trail Flower Mound, TX 75028-1954 User's Guide User's Guide User's Guide viii viii viii User's Guide User's Guide User's Guide ix ix ix TABLE OF CONTENTS Getting Assistance...............................................1 Customer Service............................................1 Getting Started..................................................4 Checking Your System Configuration..........................4 Installation................................................4 Installation Notes:.........................................4 Running CDPMenu and Government Spending.....................5 CDP GS(Government Spending) Directory Structure.............5 Introduction: Government Spending................................6 Browsing The Database............................................9 Why Use "Browse"............................................9 File Specifications.........................................9 Free Form Query / Export Report..................................12 Preparing A Report Query....................................12 Building A Report Query.....................................12 Printing Your Reports.......................................21 Sample Search Routines...........................................23 Contract Offices You Can Contact............................23 Who Might The Competition Be?...............................27 What Is Your Competition Doing?.............................30 Government Spending Fieldnames and Definitions...................33 ICAR File:..................................................33 Reporting Agency.......................................33 Contract Number........................................33 Modification Number....................................33 Contracting Office Order Number........................33 Contracting Office.....................................33 Action Date............................................34 Type of Data Entry.....................................34 Report Period..........................................34 Kind of Contract Action................................34 Dollars Obligated or Deobligated This Action...........34 Type of Obligation.....................................34 Principle Product or Service...........................36 User's Guide User's Guide User's Guide x x x Principle Standard Industrial Classification (SIC) Code .......................................................36 Advisory and Assistance Services Award.................36 Contractor Name........................................36 Contractor Establishment Code..........................36 Principal Place of Performance.........................36 Contract For Foreign Government or International Organization...........................................37 Tariff or Regulated....................................37 Number of Bidders Offering Foreign Items...............37 Buy American Act Percent Difference....................37 Country of Manufacture.................................37 Synopsis Of Procurement Prior To Award.................37 Type of Contract or Modification.......................38 CICA Applicability.....................................38 Solicitation Procedures................................38 Authority for Other Than Full and Open Competition.....38 Number of Offers Received..............................40 Extent Competed........................................40 Type of Contractor.....................................40 Woman Owned Small Business.............................40 Preference Program.....................................40 SubContracting Plan....................................40 Subject to Labor Statutes..............................41 Estimated Contract Completion Date.....................41 Demonstration Test Program.............................41 Emerging Small Business................................41 Emerging Small Business Reserve Award..................41 User's Guide User's Guide User's Guide xi xi xi Size of Small Business.................................42 Optional Reported Data Elements........................42 ICAR Status............................................43 Vendor/Contractor File:.....................................43 Contractor Establishment Code..........................43 Contractor's Name......................................43 Vendor Street Address..................................43 City...................................................43 State..................................................43 Zipcode................................................43 Product Service Information File:...........................43 Product Service Code...................................43 Product Service Name...................................43 Standard Industrical Classification Code File:..............44 SIC Codes..............................................44 SIC Name...............................................44 DOD System Code File:.......................................44 Rollup Agency Code.....................................44 Rollup Agency Name.....................................44 Department of Defense System Code......................44 Department of Defense System Name......................44 Contracting Office's File:..................................44 Reporting Agency.......................................44 Contracting Office.....................................44 Contracting Office Name................................44 Adress 1...............................................45 Address 2..............................................45 Address 3..............................................45 City...................................................45 State..................................................45 User's Guide User's Guide User's Guide xii xii xii Zipcode................................................45 Country................................................45 APPENDIX A:......................................................47 State Abbreviations and Numeric codes.......................47 APPENDIX B:......................................................49 Country Codes and Abbreviations.............................49 APPENDIX C:......................................................51 Reporting Agency Code and Name..............................51 APPENDIX D:......................................................53 Search Formulas.............................................53 INDEX............................................................56 User's Guide 1 Getting Assistance Customer Service CDP provides free assistance for all our current products. In order to receive support you must fill out the registration card included with your purchase and return it to CDP. If you have just purchased the product, our service representative will ask you the registration information so you are registered in our database. Check these items before calling for service: 1. Are you able to duplicate the problem at will? Write down the steps you had taken to get to the point where you encountered the problem. 2. Have you read the User's Guide and help files we provided with the disc? If you are unable to resolve your problem please contact our customer service group. Our office hours of operation are from 8am-5pm CST, Monday through Friday. You may contact customer service in one of five ways: 1. GEnie GEnie is the preferred method. GEnie is an online service available through General Electric Information Services that can be accessed via a modem. You can send mail directly to CDP through GEnie . CDP will send you a return response within 24 hours. Please address all correspondence to: Mail CDP. You will find GEnie allows easy, fast, and inexpensive access. If you would like a GEnie account, please contact them at 1-800-638-9636. 2. CompuServe CompuServe is a second way to communicate with us. You may address all correspondence to account # 70702,43. CDP's reponse will be sent out within 48 hours. 3. FAX Faxing us your questions is quick and easy. Send faxes to 214-394-0338 day or night and we will reply within 24 hours. 4. Telephone You may contact us by telephone. You may call 214-724-0023 M-F, 8am- 5pm CST. 5. Mail Due to the delays in mail correspondence, we do not recommend sending any support questions by mail. If you would like to comment on our User's Guide 2 products please write CD Publishing, Inc. 4960 Wolf Creek Trail, Flower Mound, TX. 75028-1954. User's Guide 3 User's Guide 4 Getting Started Checking Your System Configuration A simple test program is loaded on this CD which enables you to check the programs system requirements with your system's configuration. Run this test program first! Our examples use the letter "G" to represent the CD-ROM drive identifier C:\> G:CDPTEST (return) C:\> Exit (return) Read the information on the screen defining your system variables. The last statement will tell you if your system will run this CD-ROM title. Lack of sufficent memory and Temp variable not being set are the two most common problems. The Temp Variable problem is discussed later in this section. Too low of memory must be fixed by you. Installation This disc is managed by a proprietary piece of software called CDPMenu. When using a CDP disc for the first time you will need to install CDPMenu before using the data on the CD-ROM. CDPMenu is designed to install itself and any future CDP programs. To install place your Government Spending disc into the CD-ROM drive; at the DOS prompt type: C:\> G:CDPMENU The system will start installing itself. You are prompted to answer the following questions. 1. CDPMenu was not previously installed. Select "OK" to install or "CANCEL" to abort. 2. What directory should CDPMenu install to? Press "ENTER" to accept the default. 3. CDPMenu has determined that you need an environment variable set in your "Autoexec.bat" File. CDPMenu will update your "Autoexec.bat" for you. Select your option from below: At this point you will be prompted to reboot your system in order to save the config.sys and exe.bat file changes you have just completed. You are given the option of reviewing your installation log. If you wish to review the log press "OK" when prompted. CDPMenu is now installed. It should not be necessary to re-install CDPMenu again in order to run any of CDP's CD-ROM discs. Special note: If you should have to re-install CDPMenu at a later date, the installation process will overwrite your saved Government Spending report queries. Installation Notes: If you are installing onto floppies instead of a hard drive, the floppies used must be empty and of the high density variety. User's Guide 5 If you have previously installed CDPMenu and it is asking you about installation, check for the following line in your AUTOEXEC.BAT file: SET CDP=\CDP\ If CDPMenu does not find this variable, it will assume the program is not installed. If running on a network, map all your drives before starting CDPMenu. Changing drive mappings from the DOSShell will not be sensed by CDPMenu. If you receive the following message: "Unable to determine writable area or directory for swap files. Use/S or /? to specify swap directory or to obtain help. CDPMenu Aborting." This indicates CDPMenu or one of the other programs is unable to determine a writeable directory for it's swapfiles. Specify a hard disk directory or high density floppy drive (i.e. Set TEMP=C:\TEMP) in your autoexec.bat. Then reboot and rerun CDPMenu from the CDROM. Running CDPMenu and Government Spending From the DOS prompt, change to the CDP directory (or the one you defined) and type "CDPMenu". The "Title and Credit" screen should be seen on your monitor. From the "Title and Credit" screen you will move to the main menu screen. You will have three choices: FILE, BROWSE, and HELP. In order to access Government Spending select "Browse" and select "Packages" by pressing "Enter". You now have a choice of selecting one of three packages: 1. CDP Government Spending Database (CDPGS) Q1-3 FY92 Data 2. CDP Government Spending Database (CDPGS93) Q4 FY92 - Q3 FY93 Data 3. GEnie's Communicaton Program Aladdin The CDPMenu allows you to use multiple CDP discs without exiting this program. Each CDP update disc released will be listed as another package from which to choose. Highlight the package you wish to use and press "Enter". If you have selected a package which is not presently in your CD-ROM drive, you will be prompted to insert the appropriate disc into your drive. At this point you can either "View" the database or you can "View" our documentation. You are now ready to search the Federal Procurement Database. Congratulations! For those of you wishing to use GEnie for customer support, you will find the programs on our disc needed to initiate and install this application. Select GEine's Communication Program from your package menu in order to receive more information on this process. CDP GS(Government Spending) Directory Structure \ Root Directory, contains the CDPMenu Programs \CDP\ Contains the data files and installation scripts \GS\ Government Spending databases \Aladdin\ Aladdin Program files \CDPDOC\ CDPMenu documentation User's Guide 6 Introduction: Government Spending This database has numerous uses to you and your business, and for researching procurement activities within our federal government. However, the information you retrieve is only as good as the search criteria you use. When working with a database of this size be selective and plan your search ahead of time. Know what information you want to show on reports, and what information you want to search by. These pieces of information are normally different. There will always be at least one primary search routine which can narrow the data down considerably. In order for you to have fast searches, it is your job to locate this primary search field. Before starting your searches remember these six important points: 1. First use the "Browse" function to review the potential reportable data. 2. Be overly selective when it comes to creating search routines. 3. Uniqueness of an Individual Contract Action Report (ICAR) record is only achieved by combining five fields.(Reporting Agency, Contract Number, Modification Number, Contracting Office, and Order Number) 4. There are six files within the database. Select the file(s) which best depicts the data you want to research. 5. Several hundred thousand ICAR records exist in the ICAR file. Browsing this file becomes more efficient if you use key ranges within this file. It is also possible to use key range limitations within the other 5 files identifying certain records. Those records can then be matched to the ICAR records quickly. (i.e. if you want to look at the ICAR records who have SIC Codes of 3471-3479, you should browse the SICode file and restrict the SICode to these limitations. Once the restriction is made you can press "Enter" on any entry to see how many matching ICARs there are. When you see the ICAR records you can display or print the detail by pressing "Enter" again. 6. All files are set up so you can change the pre-defined sort criteria. Use the "Keys" button to alter the default sort criteria. An Individual Contract Action Report (ICAR) is the form which is filled out for every purchase reported to the FPDC. There are 49 fields which can be completed on each form. (See Government Spending Fieldnames and Definitions section for details of each field). When browsing the database, you will have the ability to print an ICAR record once you've identified a specific record. The printed ICAR record is two pages long. If you have an ANSI device driver loaded you can also use the "Print Screen" function to print information displayed on the screen. For sophisticated reporting we suggest utilizing the "Free Form Query/Export Report". This allows you to systematically create a defined report which fits your specification. The "Free Form Query/Export Report" allows you to continue constricting your search by keying elements within both files and fields. Use Boolean querys to allow easy search definitions as you build your reports. For extremely User's Guide 7 complex reports, we suggest using Paradox. You can find these report options when you define your report type (screen shown after selecting "New Report"). User's Guide 8 Throughout the database some fields within some records are left blank. Depending on the field, it may not need an entry or the information wasn't entered by the reporting agency. In some cases, fields are left blank for security reasons which are defined by our federal government. Whatever information remains in those records you are free to use. All information is reported by the individual agencies. CDP does not alter or restrict any of the data you see. User's Guide 9 Browsing The Database Why Use "Browse" To better understand what information you want to report on, you should first browse the database. Government Spending offers 6 different files and over 60 fields to browse. Each file offers a vast array of information leading you to eventually identify a selection of ICAR records. The "Browse" function allows you to scope out the eventual path used to create a report through the "Free Form Query/Export Report" function. Once you know what data you want, use the "Free Form Query/Export Report" to build your reports and save them for future use. The "Browse" function provides you a quick way to see how many records are available for reporting. For example, you may want to search via the Standard Industrical Classification Code (SICode) 5432 because that's the industry you represent. By browsing the SICode file you key in on that code and select it. This automatically tells you whether there are any matching ICAR records. In fact, you are placed immediately in the ICAR records. You are given an option to count the total number of matching records. With this information you can print the ICAR records or return to the "Browse" screens. The more you browse for key search elements and selections, the less time it will take to build your future reports. Once you open a file to browse you can narrow in on your desired selection by using the numeric or alpha key pad. Each file is sorted by a default field. Most files are sorted in alphabetic order. At any time during your browse you may type in a sequence of letters or numbers to isolate your search. Example: While in the Vendor/Contractor file you want to find Digital Equipment Corp. When you open the vendor file it displays a alphabetical listing of the vendors. At this point you could type "D", the letter will appear in a few seconds below the contractor establishment code column, at the same time the database will move to the first "D" vendor in the database. You could have also typed "DIGITAL", this would have brought you to the first vendor starting with the word DIGITAL. You could not have typed "DIGITAL EQUIPMENT CORP." You may not insert a space while typing a string of charactors. Once you have typed your initial charactor string you will have to re-type it if you wish to alter it in some way. This method of moving within the data is quick and easy. The "up" and "down" arrow keys can also be used to move within the database. File Specifications The Government Spending database is comprised of 6 separate, but not totally unique files. Since the ICAR is the method of data input, it is the largest file. The ICAR uses numeric, date, or alpha codes. To interpret this information 5 other files were created. Fields such as User's Guide 10 Reporting Agency, City, State, Contracting Office all need tables to translate the codes into English. Coded fields are the tying elements between the different files. Every file is tied to an ICAR record in some way. All files, except ICAR, provide common names and address for coded fields within the ICAR file. Each file contains specific information designed to make your search quicker and easier. The file names and contents are: Vendor/Contractor - This file allows for variable search routines on 5 separate fields: Contractor Establishment Code (ContEstCode), Contractor's Name (CIFVendorName), City (City), State (StateAbbr) and Zipcode (Zipcode). Any of these fields may be used as the primary sort field. Use the "Select Sort" button to change the pre-defined sort criteria. The other field contained on this "Browse" screen is (VendorStreet). Product Service Information- In this file you receive information pertaining to the Product Service Code (PrdServCode) used on the contract and the actual name of the Product or Service (PSName). Either field can be used as the sort criteria. The "Select Sort" button will change the sort selection. User's Guide 11 SIC Codes - To select contracts based on the SIC codes defined on the record, browse through this file. You can browse the screen by scrolling through the numeric SIC Codes and browse the data based on specific Standard Industrial Classification names. The "Select Sort" button will change the sort selection. DOD System Code - In this file you can search for contracts based on the agencies the contracting offices report to (RollupAgency), the DOD System code (DODSystemCod), or the DOD System name (DODSystemNam). Contracting Offices - This file contains data on 11 different fields. Seven of the fields can be used as the primary search criteria. These fields are: Reporting Agency (RptAgency), Contract Office (ContOffice), Contracting Office's Name (COName), City (City), State (StateAbbr), Zipcode (ZipCode), and Country (CountryCode). Other fields contained in this file are 3 different contractor's addresses and the state name, not abbreviated. ICAR (Individual Contract Action Report) - This is the all inclusive file. More than 45 different fields are shown for each record. For a specific definition of each data field see section titled "Government Spending Fieldnames and Definitions". Searches done through the other 5 files links you to the ICAR files automatically. For printing reports, the data will be taken from this file and captured in the report format you define. The "Select Sort" button will change the pre-defined sort criteria. User's Guide 12 Free Form Query / Export Report Preparing A Report Query To be efficient at creating good reports you must be disciplined. Take time to prepare your report. This effort will save you countless hours later. Follow the five steps listed below to help you obtain data in the format you desire. Five Steps to Report Query Success: Step 1. Browse the data files to see what information you want to report. Step 2. On paper, draft what you want your final report to look like, list headings. Step 3. Under each heading, write the file and fieldnames where data is located. Step 4. Define your search and sort criteria. (The search criteria will probably be fields you are not printing on your report). Step 5. Prioritize search criteria from most selective to least selective. (Your primary search field can be your biggest time saver). These five steps will be used in our sample searches discussed later in this chapter. Building A Report Query From the Government Spending main menu select "Free Form Query / Export Report" and press "Enter" to accept. The screen which now appears (Fig. 1) is the Main Menu for the "Free Form Query". Initially you will only have two options, "New Query" and "Set Printer Type/Port". (Fig.1) Free Form Query Main Menu New Query Set Printer Type/Port Esc-Close Enter-Select Option User's Guide 13 Figure 2 displays all options available from this menu. The menu is set up to only display those options which can be selected based on the progression of your query. (Fig. 2) Free Form Query Main Menu New Query Load Query Select Fields Select Files Save Query As... Save Query Create Computed Fields Clear Current Query Setup Report Totals Rename Query Specify Sort Criteria Delete Saved Query Restrict Search Criteria Specify Search Criteria Set Printer Type/Port Report OptionsView Last Report Generate Report/Export View Last Counts Enter- Select Option ESC to Close A brief description of each function follows: - To initiate a query you must first highlight "New Query" New Query and press "Enter". You will then be given a series of additional screens. The first of these screens (Fig. 3) asks you to define what type of query report you want to create. You are given five options: Tabular Report- A column based report with fieldnames as headers. This is the only type report which can utilize the "Setup Report Totals" function. The print restrictions of this application allow for only 132 columns (compressed). Comma Delimited ASCII File- An excellent report for transporting data to wordprocessing documents or spreadsheets. Basic ASCII code is separated by commas. Fixed Length ASCII File- Basic ASCII files which have predefined field lengths. Paradox V4.0 File- This creates files to run in Paradox V4.0. Paradox V3.5 File- This creates files to run in Paradox V3.5. User's Guide 14 (Fig.3) Report type Tabular Report Comma Delimited ASCII File Fixed Length ASCII File Paradox V3.5 File Paradox V4.0 File Enter- Select Report Type ESC to Close Once the report type is defined, you are asked to name your report. Names can be up to 30 characters. For any reports which are files you will be asked to name the file. You are restricted to using the standard eight (8) characters plus an extension. After naming the report you are retuned to the main menu. (Fig.4) Selected Files Available Files GSPSC GSVendor GSSIC GSCOffice GSICAR ESC to Close F10-Continue Enter-Select Tab-Switch Select Files- This is the first option available after creating a new report. Figure 4 displays six files you can open. To access the appropriate fieldnames, their corresponding files must be open. By highlighting any file and pressing "Enter", the selected file moves to the left side of the screen. The first file opened becomes the primary file. Carefully select a file which has the data element which you can use a "Key Range" limitation. The "Key Range" can only be used on the primary file. Figure 5 depicts the screen after two files are selected. "GSSIC" is the primary file as identified by the asterix. User's Guide 15 (Fig.5) Selected Files Available Files *GSICAR GSSIC GSPSC GSVendor GSCOffice ESC to Close F10-Continue Enter-Select Tab-Switch Select Fields- This selection only becomes available after you have opened up the files. Highlight the fields you want included in your report and press "Enter" to accept. The selections will move to the left side of the screen. On the left side of the screen is the "File Name", "Field Name", and "Print Option" (Fig. 6). (Fig.6) Selected Available File Field Print File Field GSSIC SICode Always GSICAR Dollars GSSIC SIName Always GSICAR Obligation GSICAR ContNumb Always GSICAR PrdServCode GSICAR ICARVendName Always GSICAR DODClaimant GSICAR DODSystemCod GSICAR SICode GSICAR AdvAsServAwd Columns Used: 107 The "Print Option" will default to "Always", (meaning this field will always print on your report). By pressing "Alt-P" you can choose which print options you desire: "Always", "Never ", "Unique", or "Indent Unique". "Unique" means it only prints the unique entries, no duplicates show. If you wish to change the order of your selections use "Alt-M". Simply highlight the field you want to move and press "Alt-M". With the arrow keys move the highlight bar to the spot where you want that field and press "Enter". The transiton move will ocurr. Note at the bottom of this screen is a column count status tracking the width of your report as you select different fields for printing. If you exceed 80 characters, a window appears asking if you want compressed printing. Once all fields are selected and print options defined, press "F10" to continue. Special note: This program allows for a maximum of 132 columns of compressed printing. There is not a wrap feature in this version. It will handle 245 columns of compressed printing if you have a 132 column printer. User's Guide 16 Create Computed Fields- A simple procedure where you can create your own field by calculating variables within other fields. If you wanted to calculate the field "Additional Dollars Spent" which calculates the additional dollars the government spent in order to buy an American made product create an expression like this: (GSICAR Dollars - (GSICAR Dollars/(GSICAR BuyAmerican + 1))) This expression uses two defined fields, "Dollars" and "BuyAmerican". It calculates a new field which you name. Defining the file name within the equation is only necessary if you have identical fieldnames in different files, such as State, City, and Zipcode. (Fig.7) Group File Field Total Type Grand GSSIC SICode GSSIC SIName GSICAR ContNumb Count GSICAR ICARVendName ESC to close F10-continue Enter-Edit Del-Delete Setup Report Totals- Allows the user to create totals for the different colums in their report (Fig. 7). This function can only be used when "Tabular Report" is selected. There are six Types of totals: , Count Summation , Average, Minimum, Maximum, and Standard Deviation. Each file and fieldname will be defined along with any groups you have setup. Highlight the selection you want totaled and press "Enter". (Fig.8) Group File Field Total Type Type: Picture: Grand GSSIC SICode Condition: GSSIC SIName GSICAR ContNumb Count GSICAR ICARVendName Esc-Cancel F10-Continue F2-Total Type F3-Formulas Another screen (Fig. 8) will appear. It asks you to identify the Type, and Condition Picture, . The 6 types are listed above. For Picture you have the standard options: # means numeric H means hours a means alpha or numeric M means month characters D means day 9 means numeric only Y means year X means convert all text to upper case User's Guide 17 (Fig.9) Selected Available File Field Order Group File Field GSICAR ICARVendName Ascending GSSIC SICode GSICAR ContNumb Ascending GSSIC SIName F10-Continue Enter-Select/Remove Tab-Switch Alt-M Move Alt-O Order Alt-G Group The Condition box allows you to define an expression to control your totals, such as >, <, or =. Specify Sort Criteria- On the right side of the screen, are the fields previously selected (Fig.9). In priority order, select the fields you want to have your report sorted by. Move through the fieldnames with the arrow keys and highlight the desired fields. By pressing "Enter" the field moves to the left side of the screen where you are asked to decide if you want the field sorted in ascending or descending order. Use "Alt-O" to change the order. On this screen is an option to define " which creates totals within your fields. Arrange your sort a "Group priority to match the groupings you desire. (i.e. if you want ICARVendorName grouped together on your report select that field first for sorting). This funcitonality allows sub-totals within your report for different fields. When finished, press "F10" to continue to next screen. Note: you do not have to select all of your choosen fields for sorting. Only select enough fields to provide differentiation and order in your report. This will allow similar records to be identified easily. Set Key Range- To speed up your queries we suggest first utilizing the "Key Range" function to scale down the size of your primary sort file. Your primary file selection is depicted by an asterix beside it's name in the "Select File" screen. This is the reason you prioritize your search criteria during your report preparation stage. Figure 10 shows the "Key Range" screen. Notice how similar it looks to the range limitation screens seen in the "Browse" funtion. Your primary field is stated. All you do is enter the beginning and ending ranges and press "F10" to continue. This returns you to the main menu once again. User's Guide 18 (Fig.10) Keys Ok Ok Ok +SICode +SICode +SICode +SIName Cancel Cancel Cancel Key Ranges Beginning End Clear SICode 3272 3272 Clear All Restore No Range Esc-Quit Enter-Select Option (Fig.11) File Field Search Criteria GSSIC SICode GSSIC SICName = "Adhesive" = "Adhesive" = "Adhesive" GSICAR ReportFYYR GSICAR ReportFyQrt GSICAR KdContActin GSICAR Dollars >25000 >25000 >25000 User's Guide 19 Specify Search Criteria- In this screen all fields within the choosen files are available (Fig. 11). You can search on any field and report data on different fields within the records which meet your search criteria. In this screen you can use Boolean Logical Operators. The common operators are as follows: The search terms must occur together in the same record. AND Either search term must appear in the record. OR This operator can be used alone to exclude an item. NOT >, <, = These allow you to set values greater than, less than, and equal to. *, ? Both these symbols are used as wild cards in your search. Examples of these logical operators are shown below: = "Texas" includes only Texas ="Texas" AND "Iowa" includes only Texas and Iowa in the search >="20115" AND <"20118" produces records greater than or equal to the number 20115 and less than the number 20118, as in a zipcode search produces records less than the number 3, but not equal to it <"3" ="Y" OR "YES" used for a field where the code could be Y or YES (Fig.12) Report Options Report Width 80 Page Length 66 Left Margin 0 Top Margin 2 Bottom Margin 2 Compressed Print On Skip Duplicates Off Groups on New Pages Off Report Title On Print Sort Criteria On Print Search Criteria On Column Headings On File Names On Summary Only Off F10-Continue Enter-Change Option Once the query strings are created, press "F10" to continue. This returns you to the main menu. Report Options- Figure 12 shows the screen for "Report Options" when using a "Tabular" type report. When using any of the other report types you see an "Export Options" screen (Fig. 13). This function is covered in more detail in the next section. User's Guide 20 (Fig.13) Export Options Include Header Record On Include File Names On Include Separator Off F10-Continue Enter-Change Option (Fig.14) Query Counts Records Read: 270 Records Found: 39 Records Sorted: 39 Generate Report / Export- This function executes the report generation. By highlighting this selection and pressing "Enter" your report will start processing. A screen telling you how many records are being "Read", "Found", and "Sorted" (Fig. 14) appears. After the report is compiled the screen returns to the main menu immediately. If you want to check your report totals use the "View Last Counts" option. Load Query- This function loads a previously saved query. By selecting this option a screen displays the previously saved queries allowing you to choose the query of your choice. Save Query- This function saves the current query. By highlighting this selection and pressing "Enter" your query will be saved. No additonal screens will appear. Save Query As- This allows you to save your existing query under a different name. Clear Current Query- Using this function will delete your existing query. Rename Query- If you loaded a saved query and wish to rename it, use this option. This allows you to revise queries without having to save them using "Save Query As". User's Guide 21 Delete Saved Query- This query allows you to delete any of the previously saved queries. Set Printer Type/Port- This selection defines your printer type and port. First, select port, then select printer type. If you do not find your specific printer, use the "ASCI Basic Printer". View Last Report- This option will allow you to instantly view the last generated report. View Last Counts- By using this selection you can always view the number of records read, found, and sorted on the last generated report. Printing Your Reports To print your reports do 3 things: 1. Select your printer port and printer type 2. Define your report Options 3. Decide where you want your report to print Select your printer port and printer type in the "Set Printer/Port" selection on the main menu. Highlight this option and press "Enter". You will be prompted to select your port and printer type. "ANSI Basic Printer" is the default printer type. If you do not find your printer listed, use this selection. Setting your "Report Options" is simple. This funtion has predefined report options, but we advise you to look at them to inform yourself of what your final output will be. Highlight "Report Options" from the main menu. The "Report Option's" screen will appear giving you 14 options. Use the arrow keys to move around the screen and change the appropriate lines. If you have selected a report type other than '"Tabular", the "Export Options" screen will appear instead of the "Report Options" screen. When completed, press "F10" to continue. Printing your report is selected from the main menu via the "Generate Report/Export" option. Highlight this option and press "Enter". You are prompted to define where to print your report: to your printer, to your screen, or to a file if you had selected "Tabular" as your report type,otherwise a file is generated. Press "Enter". The system will start processing your report. A window will appear showing the number of records found, read, and sorted. When this function is complete the printing action begins. Note: actual time to find, read, and sort records is based off your search and sort criteria. Remember, your paper print capabilities are limited to 132 columns compressed printing. There is not a wrap feature in this version of the software. If you need to print a wider report do not select "Tabular" as your report type. Choose one of the following which best meets your needs: Comma Delimited ASCII File Fixed Length ASCII File Paradox V4.0 File User's Guide 22 Paradox V3.5 File User's Guide 23 Sample Search Routines Contract Offices You Can Contact The most important aspect of selling to the government is knowing which agencies are buying your products or services and which of their contracting offices you need to contact to get on their bidders list. Described below is how you would make this type of search. Example 1. Problem: John Doe owns a cement products company in Dallas, Texas with manufacturing outlets in Houston, San Antonio, and Lubbock. He sells primarily within the Texas geography. He knows the government buys similar cement products as his, because he's seen them. He doesn't know who to contact to get the opportunity to bid. Preparing his search- In analyzing John's problem you know he wants the names and addresses of contracting offices in Texas who have been contracting for his type of product. This is how he would search for what he needs: Step 1.- By browsing the data files, John found the SIC Code which matches his business, 3272. John allowed his browse to take him into the ICAR records where he counted 39 records matching the SIC Code. John also scrolled across the ICAR records to where the services were delivered and found some in Texas. Step 2. - Next he drafts out what he wants his report to look like. He makes it simple: Contract # Mod. # Order # Dollars Cont Off Name Address City State Zip Step 3 - He then lists the files and fieldnames under each heading. Fieldnames: (COName) (ContOfOrNumb) (COName) (Address1- 2-3) (State) (Mod Numb) (Dollars) (City) (ZipCode) File Names: ICAR ICAR ICAR ICAR COffice COffice COffice COffice Step 4 - His primary search criteria can be the SIC Code 3272. He will be able to perform a key range search on it as his primary file. His only other search criteria will be to limit the records to the state of Texas. He uses the State field in the COffice file. By looking in Appendix A, he knows to use 48 as the code for Texas. In this example he wants to have the data sorted by Vendor Name, then Dollars. User's Guide 24 Step 5 - Since his SIC Code should eliminate the majority of records he uses it as his primary file and perfroms the key range search on it first. Through the "Specify Search Criteria" function, he then sets the fieldname (State), within the COffice file, = 48. User's Guide 25 Having planned his report he sees the address fieldnames he selected will exceed the 132 columns available for printing. So he chooses to do a Comma Delimited ASCI File report. Then he embeds the file into a word processing document which he uses later to create mailing lists. After naming his report he enters the data he already defined. Upon doing the report generation he sees there were 39 records within this SIC code and only 4 matching the state requirement. (Fig.15) (Fig.15 part I) "ContNumb" ModNu ContOfOrN Dollars mb umb "V580P5154 " " " " " 177000 "V846P1998 "J16002 " " " " 43000 "DAJA0292C0 " "0220 059 " " " 92000 "DAAD0192D0 "2337 " 210 " " " 28000  (Fig.15 part II) COName COAddress1 "DEPARTMENT OF "VA MED CTR" VETERANS AFFAIRS" "DEPARTMENT OF "FORT SAM HOUSTON VETERANS AFFAIRS" CEMETERY" "DOD/DEPARTMENT OF "Regional Contrng THE ARMY" Off Seckenheim" User's Guide 26 "DOD/DEPARTMENT OF "USA Yuma Proving THE ARMY" Ground" (Fig.15 part III) COAddre COAddre City State ZipCod ss3 ss2 e "" "2002 "HOUSTO "TEXAS" "77211 HOLCOMB N" " E BLVD." "1520 "" "SAN "TEXAS" "78209 HARRY ANTONIO " WURZBAC " H RD." "Unit "Attn: "New "NEW "09333 AEUCC- 29331 York" YORK" 5000" APO AE S" 09266" "Attn: "Procur "Yuma" "ARIZON "85365 ement STEYP- A" 9103" CR" Directo rate" User's Guide 27 Who Might The Competition Be? It is always nice to know who your competition is, what contracts they have, and how much they bid for them. In example 2 you learn how you can search for your competition. Example 2. Problem: Lori Woody considered starting up her own food service company catering to the military institutions around her residence in New Mexico. She knew she could take advantage of the 8a laws oriented towards Women Owned Businesses. Lori wanted to know if there were any other Woman Owned businesses providing this type service already contracting with the military installations in her area. She also wanted to know how large the contracts were that she might be competing for. Preparing Her Search: Lori knows she's looking for 3 basic pieces of information. 1) SIC code for food services or eating places, 2) What opportunities exist in New Mexico, and 3) Are there any existing Woman Owned Businesses already doing this in her area. Step 1- First, Lori starts scanning the "Browse" function. Since she wants to enter the food service business she browses the "GSSIC" file for her industry. Eating Places is the most similiar industry. She notes the SIC code as 5812. While browsing this file she looks into the ICAR file to see if any records match. After performing a "Count" option she sees 270 records matching the 5812 SIC Code. Step 2- On paper she drafts out what she wants her report to look like. She decides to print the following fields on her report: ICARVendorName City Dollars EstCompDateY EstCompDateM WomanOwned Step 3- All this information comes from the file called ICAR. Since her primary key field is SICode, she opens the only the ICAR file and restricts her key field to 5812. Step 4- There are only two fields needed to complete this search, State and SICode. In order to keep her records together she sorts the data by ICARVendoName and then EstCompDateY. This will provide order to her finished report. Step 5- SIC code 5812 is her best search criteria, she plans on using it with the "Key Range" option. Her only other search criteria will be on (StateAbbr). She is looking for businesses in New Mexico. By referencing Appendix A, she uses "35" as the state abbreviation. After performing the above five steps she needs to enter the "Free Form Query" and enter the data as defined. The report generation shows there were 270 records within SIC Code 5812 and of those there were 14 records meeting the State requirement. When Lori looks at her report she sees that none of the listings are Woman Owned. Lori could have entered search criteria for WomanOwned = "0". If she had she would not have found any matches. By printing that field on the report she can User's Guide 28 see what other competition there is. Figure 16 depicts her final report. User's Guide 29 (Fig.16) Sort: GSICAR ICARVendName (Ascending) and GSICAR EstComplete (Ascending) Where: GSICAR StateAbbr ="35" GSICAR GSICAR GSICAR GSICAR WOMEN ICARVendName CITY DOLLARS ESTCOMPDATE OWN CHOICE INSTITUTIONAL SUPPLY CO $114, 000 09/01/92 No COMM MORALE WELFARE RECREATION $52, 000 09/01/92 No DEE LITE CATERING RATON $83, 000 06/01/92 No EASTERN NEW MEXICO REHAB SVC CANNON AIR FORC $64, 000 09/01/92 No SAUDI ARABIAN TRAD & CONST CO $247, 000 06/01/92 Unk SAUDI ARABIAN TRAD & CONST CO $163, 000 08/01/92 Unk SAUDI ARABIAN TRAD & CONST CO $43, 000 08/01/92 Unk SPEEDY FOOD SERVICE INC HOLLOMAN AIR FO $62, 000 09/01/92 No SPEEDY FOOD SERVICE INC HOLLOMAN AIR FO $50, 000 09/01/92 No SPEEDY FOOD SERVICE INC HOLLOMAN AIR FO $61, 000 09/01/92 No TAYLOR INTERNATIONAL $153, 000 09/01/92 No UNITED CATERERS & CONTRACTOR $149, 000 09/01/92 No UNITED CATERERS & CONTRACTOR $79, 000 09/01/92 No User's Guide 30 ZUR POST $117, 000 09/01/92 No What Is Your Competition Doing? Any business knows you must keep an eye on your competition. Through use of this program you can quickly develop a report on any competitor and see what business they have with the government. Example 3 depicts a simple competitor report. Example 3 Paul Stickem is in the adhevsive business. He has two big competitors he'd like to mount an offensive against for the coming contract year. He wants to know what each competitor is doing in contracting with the government, how large the contracts are, what the contract numbers are, and completion dates of these contracts. How does he start? User's Guide 31 Preparing the Search- Paul could go into "Browse" and obtain all the information he is looking for or he could print it on a report. For ease of reading, the report is the best option. The product, Adhesives, is the best limitor and his competitors names will hone in on the final records. Step 1 - After browsing the data files, he finds the government has a product service code called Adhesives, a perfect match for his business. Following through with the browse he looks into the ICAR matching records for Adhesive and finds 152 matching records. By quickly scanning the vendor names he sees both the competitors names: Faber Castell Corp and Polymeric System, Inc. Step 2 - The report he wants to print will show the following headers: ICARVendName Cont. # Order # Dollars Est. Comp DateY Est Comp Date M Step 3 - The information for the report is generated from one file, ICAR. In order to isolate the product service code he opens the PSCode file. The fieldnames are those listed above. Step 4 - The search criteria is simple. He uses PSCode 8040 which matches the Adhesive product name. (He could have also searched by "Adhevsive"). His other search criteria becomes the competitors names. For sorting purposes he wants the competitors listed separately and individually sorted by EstCompDateY. Step 5- The most constraining search can take place on PSCode. Both competitors provide other products besides adhesives, but he does not want those records. The second criteria will be on the ICARVendName. Using "Key Range" he limits his PSCode to 8040. Then he places an expression in the "Specify Search Criteria" option. The expression he uses is: ICARVendName = "Faber Castell Corp" OR (GSICARVendName="Poly") Notice how he did not use the full name for the second competitor. The program will apply the letters he supplied and find anything that starts with those same letters. He could have done the same with Faber. In the second part of the equation he identified both the file and fieldname. With two or more variables you must always identify their file and fieldnames. Having completed the entries he generates his report. (Fig.17) The record counter shows 152 records found and 39 records matched. The report he generated displays both his competitors and their corresponding contracts. Only a portion of his report is shown. User's Guide 32 Adhesives report Where: GSICAR ICARVendName ="Faber Castell" or (gsicar icarvendname="poly") GSICAR GSICAR GSICAR GSICAR GSICAR ICARVendName ContNumb ContOfOrNumb Dollars EstComplete FABER CASTELL CORP GS10F51935 AWB06621 $3,000 10/01/92 FABER CASTELL CORP GS10F51935 NWB06622 $5,000 10/01/92 FABER CASTELL CORP GS10F51935 NWB06932 $4,000 10/01/92 FABER CASTELL CORP GS10F51935 AWB06931 $3,000 10/01/92 FABER CASTELL CORP GS10F51935 AWB06341 $6,000 09/01/92 FABER CASTELL CORP GS10F51935 SWB06343 $6,000 09/01/92 FABER CASTELL CORP GS10F51935 NWB06342 $4,000 09/01/92 POLYMERIC SYSTEMS, . GS10F52098 TXDSD20491 $1,000 09/01/92 (Fig.17) User's Guide 33 Government Spending Fieldnames and Definitions ICAR File: Reporting Agency ICAR Item 1 Fieldname: (RptAgency) - Each agency has a unique 4-digit code. (See Appendix C for these codes). Each Reporting Agency has a roll up agency it is assigned to. (i.e. there are many Reporting Agencies within the Department of Defense) Contract Number ICAR Item 2 Fieldname: (ContNumb) - This number represents the contract or purchase order number. It is not a uniquely identifying number. This number is used to identify an order against a federal schedule contract or indefinite delivery contract. It is also used to report the Basic Ordering Agreement number. For contracts under section 8(a) of the Small Business Act, the reporting agency assigns the number. This is a good field to have printed on your report, but not a good field to search by, unless you are looking for a specific contract that could have multiple orders placed against it. Modification Number ICAR Item 3 Fieldname: (ModNumb) - When doing a modification to a contract the reporting contracting office will assign a number. Termination of contracts are considered modifications. When doing sorts be sure to include this field so you may see all modifications against the orders. Contracting Office Order Number ICAR Item 4 Fieldname: (ContOfOrNumb) - This is a unique number assigned by the contracting office to identify delivery orders, task orders, and calls placed against indefinite delivery contracts, federal schedule contracts, or basic ordering agreements. Contracting Office ICAR Item 5 Fieldname: (ContOffice) - This is a five character code assigned by the agency that uniquely identifies the purchasing or contracting office. User's Guide 34 Action Date ICAR Item 6 Fieldname: (ActionDate) - This represents the date of award or date a mutually binding agreement was reached. Type of Data Entry ICAR Item 7 Fieldname: (TypeofEntry) - A single digit code defines whether this record is original, deleting, or correcting. 0= Original - used to report an action which has not been previously reported. 1= Deleting - a deletion of a matching action (one that is identical in fields 1-6 of the ICAR). 2= Correcting - to correct a previously reported action. Report Period ICAR Item 8 Fieldnames: (ReportFYYr) and (ReportFYQtr) - Three digits are used to define the date which the data was reported by the agency. The first two digits represent the fiscal year and the last digit represents the quarter. Kind of Contract Action ICAR Item 9 Fieldname: (KdContAction) - Eleven codes are used to define the action reported. 0 = Initial letter contract 1 = Definitive contract superseding a letter contract 2 = New definitive contract 3 = Small purchase procedure 4 = Order under indefinite delivery contract (IDC) 5 = Order under basic ordering agreement (BOA) 6 = Order/modification under federal schedule 7 = Modification 8 = Termination for default 9 = Termination for convenience 10 = Initial load of federal contract schedule (this code is reserved for use by GSA, VA, and OPM ) Dollars Obligated or Deobligated This Action ICAR Item 10 Fieldname: (Dollars) - This field represents the dollars obligated or deobligated in the reported action. Eight digits are used. The dollars are rounded to the nearest whole dollar. If the (KdContAction) file is code 10 this field will not have an entry. Type of Obligation ICAR Item 11 Fieldname: (Obligation) - A single digit code is used to define whether the dollars are being obligated or deobligated. 0 = Obligated, User's Guide 35 1 = Deobligated. If (KdContAction) file is coded 10, this field is blank. User's Guide 36 Principle Product or Service ICAR Item 12 Fieldname: (PrdServCode) - A four digit code is used to identify the predominate product or service. Definition of codes can be found in the FPDS Product and Service Codes Manual. There is not a hard copy listing of these codes within this manual. You may use the browse function to identify the PrdServCode listings. An example of this type action is provided in the chapter called "Browsing The Database". This field is blank if field (KdContAction) is code 10. Principle Standard Industrial Classification (SIC) Code ICAR Item 13 Fieldname: (SICode) - A four digit code is used to describe the principle industry the action report represents. Code listings can be found in the OMB Standard Industrial Classification Manual. The SIC table can be found in the SIC Codes file. Advisory and Assistance Services Award ICAR Item 14 Fieldname: (AdvAsServAwd) - A single digit code to designate whether or not the action is an advisory assistance award. (0) for yes, (1) for no. Advisory and Assistance services are those services acquired from non-governmental sources by contract or by personnel appointment to support or improve agency policy development, decision-making , management, and administration, or to support or improve the operation of management systems. Contractor Name ICAR Item 15 Fieldname: (ICARVendorName) and (ICARParentName) - These fields contain up to 30 characters of the contractor's name which received the award for the contract. Both the contractor's name and the contractor's parent name will be displayed on the ICAR record. Contractor Establishment Code ICAR Item 16 Fieldname: (ContEstCode) - A nine digit alpha-numeric contractor establishment number is assigned by Dun & Bradstreet that identifies the contractor establishment receiving the award. The reporting agency is responsible for obtaining this number from Dunn & Bradstreet. Within our Contractor/Vendor file this information is displayed along with the contractor's name (CIFVendorNam) and the address (COAddress1) (COAddress2) (COAddress3) pulled from Dun & Bradstreet number. Principal Place of Performance ICAR Item 17 Fieldname: (StateAbbr), (PerfCityCode), (CountryCode ) - In order to search principal place of performance you have the ability to define User's Guide 37 the 3 separate fields as defined above. This field refers to the contractor's final manufacturing assembly point, processing plant , construction site, place where a service is performed, location of mines, or where a product is grown. Contract For Foreign Government or International Organization ICAR Item 18 Fieldname: (ForGovContra) - A (0) yes or (1) no field which defines whether any foreign government or international organization bears any part of the cost of the action. If code is (0), ICAR items 19-34 and 39-47 will be left blank. Tariff or Regulated ICAR Item 19 Fieldname: (TariffRegula) - A (0) yes or (1) no response to whether the action involves a tariff or regulated acquisition when the supplier is a sole source and service rates are fixed or adjusted by a Federal, State,or other public regulatory body. Number of Bidders Offering Foreign Items ICAR Item 20 Fieldname: (NumBidForeig) - Reports the number of bidders or offerors offering foreign end items worth 51 percent or more of the contract value. If none, 0 is reported, if 9 or more, the number 9 is reported. Buy American Act Percent Difference ICAR Item 21 Fieldname: (BuyAmerican) - If the evaluation factor under the Buy American Act was used and resulted in an award to a concern offering a domestic product, the actual difference between the award price and the lowest priced foreign product computed before application of the Buy American differential will be reported. The percent difference is calculated by dividing the difference (award price minus the lowest priced foreign product) by the lowest priced foreign product. The reported percentage will be shown as a whole number. If the Buy American evaluation was not used, two zeros will be shown. Country of Manufacture ICAR Item 22 Fieldname: (CountryManuf) - A two digit code representing the country where the acquired supplies or equipment were manufactured, mined or grown. The "Browse" function can be used to identify country codes while in the program or they can be looked up in Appendix B. Synopsis Of Procurement Prior To Award ICAR Item 23 User's Guide 38 Fieldname: (SynopsisProc) - A single digit code defining whether the action was synopsized prior to award based on the Commerce Business synopsis requirements. Daily 0 = Synopsized prior to award 1 = Not synopsized due to urgency 2 = Not synopsized due to other reasons Type of Contract or Modification ICAR Item 24 Fieldname: (TypeContMod) - A single digit code representing the predominance of dollars obligated or deobligated for the contract action. 0 = Fixed price redetermination 5 = Cost-no fee 1 = Firm fixed price 6 = Cost Sharing 2 =Fixed price with economic 7 = Cost-plus-fixed fee price adjustment 8 = Cost-plus-incentive fee 3 = Fixed price incentive 9 = Time and materials 4 = Cost-plus-award fee 10= Labor hour CICA Applicability ICAR Item 25 Fieldname: (CICAApp) - Single digit code defining CICA applicability. 0 = CICA Applicable. This code is used if the action resulted from a solicitation issued on or after April 1, 1985 and code 1 or code 2 did not apply. 1 = Small Purchase procedure pursuant to procedures in FAR Part 13. 2 = Subject to statute other than CICA. Can only be used if legislation authorizes the agency to use procurement procedures not covered by the CICA statute. 3 = Pre-CICA. This code is used for any actions resulting in a solicitation being issued before April 1, 1985, irrespective of the award date. Solicitation Procedures ICAR Item 26 Fieldname: (SolicProc) - If ICAR item 25 is defined as code (0) this field will be filled in. If not it is left blank. Codes (0-9) designate the solicitation procedures available to provide full and open competition as set forth in FAR Subparts 6.1 and 6.2. Code (10) designates the solicitation procedure for contracting without providing for full and open competition. 0 = Full and open competition - sealed bid 1 = Full and open competition - competitive proposal 2 = Full and open competition - combination 3 = Architect-engineer 4 = Basic research proposal 5 = Multiple award schedule 6 = Alternate source-reduced cost 7 = Alternate source-mobilization 8 = Alternate source-engineer /R&D capability 9 = Set-Aside 10= Other than full and open competition Authority for Other Than Full and Open Competition User's Guide 39 ICAR Item 27 Fieldname: (AuthForComp) - This field provides justification for using code (10) in ICAR Item 26. 0 = Unique source 7 = Urgency 1 = Follow-on Contract 8 = Mobilization 2 = Unsolicited research 9 = Essential R&D capability proposal 10 = International agreement 3 = Patent/data rights 11 = Authorized by statute 4 = Utilities 12 = Authorized resale 5 = Standardization 13 = National security 6 = Only one source-other 14 = Public Interest User's Guide 40 Number of Offers Received ICAR Item 28 Fieldname: (NumberOffers) - If ICAR Item 25 was coded (0), this field will define if more than one offer was received. (0) means one offer was received, (1) means two or more offers were received. Extent Competed ICAR Item 29 Fieldname: (ExtentCompet) - A single digit code defining what level the action was competed. 0 = Competed Action 1 = Not available for competition 2 = Follow-on to competed action 3 = Not competed, used when codes 0, 1, and 2 do not apply Type of Contractor ICAR Item 30 Fieldname: (VendorType) - Codes in this field represent information based on contractors size, type, and location. 0 = Small Disadvantaged 7 = State/local government- Business education 1 = Other Small Business 8 = State/local government 2 = Large Business hospitals 3 = Sheltered Workshop 9 = Other State/local 4 = Nonprofit educational government (i.e. research organizations organizations) 5 = Nonprofit hospitals 10 = Foreign Contractor 6 = Other nonprofit 11 = Domestic Contractor organizations performing outside the U.S. Woman Owned Small Business ICAR Item 31 Fieldname: (WomanOwned) - A (0) yes , (1) no field indicating whether the contractor is certified as a woman owned business. Preference Program ICAR Item 32 Fieldname: (PreferProg) - A single digit code defining the preference program used in making the award. 0 = Directed to sheltered 4 = Labor surplus area set-aside workshop 5 = Tie-bid preference 1 = 8(a) program 6 = Buy Indian/Self- 2 = Combined labor surplus Determination Act area/small business set-aside 7 = No preference program or not 3 = Small Business set-aside listed SubContracting Plan (Small and Disadvantaged Business) ICAR Item 33 Fieldname: (SubContPlan) - A single digit code defining whether a sub- contracting plan is required for this contract. (0) means it is required, (1) means it is not required. User's Guide 41 Subject to Labor Statutes ICAR Item 34 Fieldname: (LaborStatues) - Represents the predominance of dollars obligated or deobligated for the contract action under certain labor statutes. 0 = Subject to Walsh-Healy Act-Manufacturer 1 = Subject to Walsh-Healy Act-Regular Dealer 2 = Subject to Service Contract Act 3 = Subject to Davis-Bacon Act 4 = Not subject to any of the above Acts Estimated Contract Completion Date ICAR Item 35 Fieldname: (EstCompDateY) and (EstCompDateM) - In order to access this field you have two files in which to sort data on . The first two digits are for year, and the third and fourth digits represent the month. Demonstration Test Program ICAR Item 42 Fieldname: (DemoTestProg) - Only participating agencies under the Small Business Competitiveness Demonstration Program complete ICAR items 42-45. This file defines whether this action is or is not a Demonstration Program. (0) yes, (1) no. Emerging Small Business ICAR Item 43 Fieldname: (EmergSmBus) - This field defines whether this action is for an emerging small business in one of the four designated industry groups. The four industry groups are construction, A&E services (including surveying and mapping), refuse systems and related services, and non-nuclear ship repair. This field will only be filled out if ICAR Item 42 is (0). (0) means Yes, (1) means no. Emerging Small Business Reserve Award ICAR Item 44 Fieldname: (ESBSetAside) - A yes (0) or no (1) response indicates whether the contract action resulted from an award that was reserved for emerging small business concerns. However, contract actions that are modifications within the scope of work of contracts above the emerging small business threshold shall not be reported as emerging small business reserve awards. Follow-on awards, limited to one source, shall be coded (1). This field is only completed if ICAR item 43 is coded (0). User's Guide 42 Size of Small Business ICAR Item 45 Fieldname: (SizeOfSmBus) - A single digit code defines either the number of employees or average gross revenue of the small business. 0 = 50 or less employees 8 = Upto $2M in gross revenue 1 = 51 to 100 employees 9 = Upto $3.5M in gross 2 = 101 to 250 employees revenue 3 = 251 to 500 employees 10 = Upto $5M in gross revenue 4 = 501 to 750 employees 11 = Upto $10M in gross revenue 5 = 751 to 1000 employees 12 = Upto $17M in gross revenue 6 = Over 1000 employees 13 = Anything over $17M 7 = $1M or less in gross revenue Optional Reported Data Elements ICAR Item 47 This portion of the ICAR report is used for agencies to report unique data that FPDC uses for information requests. Listed below are fields and Fieldnames for data reported in this field. Fieldname: (MultiYear) Data on multi-year contracting is reported for the DOD and Civilian agencies with Multi-Year contracting authority. Fieldname: (SBSetAside) Represents data on Small Disadvantaged Business Set-Asides for DOD only. Fieldname: (DD350Report) This field defines the Department of Defense's 350 Report number. Fieldname: (EthnicGroup) Data on ethnic groups, reported by DOD only. 0 = Subcontinent Asian American 4 = Native American 1 = Asian Pacific American 5 = Other SDB (certified by SBA) 2 = Black American 6 = No representation 3 = Hispanic American Fieldname: (Handicapped) Initial award to a Public or Private Organization for the Handicapped, referred to as "Sheltered Workshop" under a small business set-aside. Fieldname: (NextHigherSB) Reports the amount of the next higher bid submitted by a "for- profit"small business under the solicitation resulting in the award to the Sheltered Workshop. This is a twelve digit field. Fieldname: (DODClaimant) Defines the Department of Defense Program Code Fieldname: (NASAActions) Defines the number of multiple procurement actions per transaction for NASA. User's Guide 43 ICAR Status ICAR Item 49 Fieldname: (ICARStatus) - Define whether this record is active or deleted. You should not see any deleted actions in this database. Vendor/Contractor File: Contractor Establishment Code Fieldname: (ContEstCode) - Identical to the ICAR item 16. Represents a 9 digit code assigned by Dun & Bradstreet identfying the contractor's establishment receiving the award. Contractor's Name Fieldname: (CIFVendorName) - Identifies the vendor's name as identified on the Dun & Bradstreet listing. Vendor Street Address Fieldname: (VendorStreet) - Provides the street address for the contractor establishment code. City Fieldname: (City) - Identifies the city for the contractor establishment code. State Fieldname: (StateAbbr) - Provides a two digit alpha code identifying the state of origin. Zipcode Fieldname: (Zipcode) - Provides the numeric zipcode. Product Service Information File: Product Service Code Fieldname: (PrdServCode) - Same identifier as ICAR item 12. A four digit code identifying the principal product or service. Definitions of codes can be found in the FPDS Product and Service Code Manual. Product Service Name Fieldname: (PSName) - Provides a descriptive name related to the the product service code. User's Guide 44 Standard Industrical Classification Code File: SIC Codes Fieldname: (SICode) - Same as ICAR item 13. Defines the SIC code most closely associated with the action report. SIC Name Fieldname: (SICName) - Provides a descriptive name for the SIC Code. DOD System Code File: Rollup Agency Code Fieldname: (RollupAgency) - Provides a four digit code representing the agency which the contracting office reports to. Rollup Agency Name Fieldname: (RUAgencyName) - Provides a descriptive name for the Rollup Agency Code. Department of Defense System Code Fieldname: (DODSystemCod) - Each system within the defense department has an identifying weapon's code. The codes are in the table but it does not mean a purchase is made against that code. Department of Defense System Name Fieldname: (DODSystemNam) - Provides a descriptive name for the DOD System Code. Contracting Office's File: Reporting Agency Fieldname: (RptAgency) - Same as ICAR item 1. Represents a unique four digit code assigned to each agency. Contracting Office Fieldname: (ContOffice) - Same as ICAR item 5. A five character code assigned to the contracting offices. Contracting Office Name Fieldname: (COName) - This field shows the contracting office's name. User's Guide 45 Adress 1 Fieldname: (Address1) - Represents first line of the contracting office's address. Address 2 Fieldname: (Address2) - Represents second line of the contracting office's address. Address 3 Fieldname: (Address3) - Represents the third line of the contracting office's address. City Fieldname: (City) - Defines the city location of the contracting office. State Fieldname: (StateAbbr) - Identifies the 2 digit numeric abbreviation for the state. See appendix A for state abbreviation codes. Zipcode Fieldname: (Zipcode) - Identifies the contracting office's zipcode. Country Fieldname: (CountryCode) - Identifies the country where the contracting office is located. Normally left blank if contractor is within the USA. Refer to appendix B for the 2 digit numeric codes User's Guide 46 User's Guide 47 APPENDIX A: State Abbreviations and Numeric codes (StateAbbr) State 01 AL, ALABAMA 28 MS, MISSISSIPPI 02 AK, ALASKA 29 MO, MISSOURI 04 AZ, ARIZONA 30 MT, MONTANA 05 AR, ARKANSAS 31 NE, NEBRASKA 06 CA, CALIFORNIA 32 NV, NEVADA 08 CO, COLORADO 33 NH, NEW HAMPSHIRE 09 CT, CONNECTICUT 34 NJ, NEW JERSEY 10 DE, DELAWARE 35 NM, NEW MEXICO 11 DC, DISTRICT OF COLUMBIA 36 NY, NEW YORK 12 FL , FLORIDA 37 NC, NORTH CAROLINA 13 GA, GEORGIA 38 ND, NORTH DAKOTA 15 HI , HAWAII 39 OH, OHIO 16 ID, IDAHO 40 OK, OKLAHOMA 17 IL, ILLINOIS 41 OR, OREGON 18 IN, INDIANA 42 PA, PENNSYLVANIA 19 IA, IOWA 44 RI, RHODE ISLAND 20 KS, KANSAS 45 SC, SOUTH CAROLINA 21 KY, KENTUCKY 46 SD, SOUTH DAKOTA 22 LA, LOUISIANA 47 TN, TENNESSEE 23 ME, MAINE 48 TX, TEXAS 24 MD, MARYLAND 49 UT, UTAH 25 MA, MASSACHUSETTS 50 VT, VERMONT 26 MI, MICHIGAN 51 VA, VIRGINIA 27 MN, MINNESOTA 53 WA, WASHINGTON User's Guide 48 54 WV, WEST VIRGINIA 69 MP, NORTHERN MARIANA ISLANDS 55 WI, WISCONSIN 70 PW, PALAU 56 WY, WYOMING 72 PR, PUERTO RICO 60 AS, AMERICAN SAMOA 74 UM, U.S. MINOR OUTLYING 64 FM, FEDERATED STATES OF ISLANDS MICRONESIA 78 VI, VIRGIN ISLANDS OF THE 66 GU, GUAM U.S. 68 MH, MARSHALL ISLANDS User's Guide 49 APPENDIX B: Country Codes and Abbreviations AA ARUBA CK COCOS (KEELING) GJ GRENADA AC ANTIGUA & ISLANDS GK GUERNSEY BARBUDA CM CAMEROON GL GREENLAND AF AFGHANISTAN CN COMOROS GM GERMANY AG ALGERIA CO COLOMBIA GO GLORIOSO ISLANDS AJ AZERBAIJAN CR CORAL SEA GP GUADELOUPE AL ALBANIA ISLANDS GR GREECE AM ARMENIA CS COSTA RICA GT GUATEMALA AN ANDORRA CT CENTRAL AFRICAN GV GUINEA AO ANGOLA REPUBLIC GY GUYANA AR ARGENTINA CU CUBA GZ GAZA STRIP AS AUSTRALIA CV CAPE VERDE HA HAITI AT ASHMORE & CARTER CW COOK ISLANDS HK HONG KONG ISLANDS CY CYPRUS HM HEARD & MCDONALD AU AUSTRIA CZ CZECHOSLOVAKIA ISLAND AV ANGUILLA DA DENMARK HO HONDURAS AY ANTARCTICA DJ DJIBOUTI HR CROATIA BA BAHRAIN DO DOMINICA HU HUNGARY BB BARBADOS DR DOMINICAN IC ICELAND BC BOTSWANA REPUBLIC ID INDONESIA BD BERMUDA EC ECUADOR IM MAN, ISLE OF BE BELGIUM EG EGYPT IN INDIA BF BAHAMAS,THE EI IRELAND IO BRITISH INDIAN BG BANGLADESH EK EQUATORIAL OCEAN TERRITORY BH BELIZE GUINEA IP CLIPPERTON BK BOSNIA AND EN ESTONIA ISLAND HERCEGOVINA ES EL SALVADOR IR IRAN BL BOLIVIA ET ETHIOPIA IS ISRAEL BM BURMA EU EUROPA ISLAND IT ITALY BN BENIN FA FALKLAND ISL- IV IVORY COAST BO BYELARUS I.MALVINAS IY IRAQ-SAUDI BP SOLOMON ISLANDS FG FRENCH GUIANA ARABIA NEUTRAL ZONE BR BRAZIL FI FINLAND IZ IRAQ BS BASSAS DA INDIA FJ FIJI JA JAPAN BT BHUTAN FK FALKLAND ISL- JE JERSEY BU BULGARIA MALVIANAS JM JAMAICA BV BOUVET ISLAND FO FAROE ISLANDS JN JAN MAYEN BX BRUNEI FP FRENCH POLYNESIA JO JORDAN BY BURUNDI FR FRANCE JU JUAN DE NOVE BZ GERMANY, BERLIN FS FRENCH S. & ISLAND CA CANADA ANTAR LANDS KE KENYA CB CAMBODIA GA GAMBIA, THE KG KYRGYZSTAN CD CHAD GB GABON KN DEM PEOPLES REP. CE SRI LANKA GC GERMAN KOREA CF CONGO DEMOCRATIC REPUBLIC KR KIRIBATI CG ZAIRE GE GERMANY, FEDERAL KS KOREA, REPUBLIC CH CHINA REPUBLIC OF OF CI CHILE GG GEORGIA KT CHRISTMAS ISLAND CJ CAYMAN ISLANDS GH GHANA KU KUWAIT GI GIBRALTAR LA LAOS User's Guide 50 LE LEBANON NZ NEW ZEALAND TI TAJIKISTAN LG LATVIA PA PARAGUAY TK TURKS CAICOS LH LITHUANIA PC PITCAIRN ISLANDS ISLANDS LI LIBERIA PE PERU TL TOKELAU LS LIECHTENSTEIN PF PARACEL ISLANDS TN TONGA LT LESOTHO PG SPRATLY ISLANDS TO TOGO LU LUXEMBOURG PK PAKISTAN TP SAO TOME LY LIBYA PL POLAND PRINCIPE MA MADAGASCAR PM PANAMA TS TUNISIA MB MARTINIQUE PO PORTUGAL TU TURKEY MC MACAU PP PAPUA NEW GUINEA TV TUVALU MD MOLDOVA PU GUINEA-BISSAU TW CHINA (TAIWAN) MF MAYOTTE QA QATAR TX TURKMENISTAN MG MONGOLIA RE REUNION TZ TANZANIA MH MONTSERRAT RO ROMANIA UG UGANDA MI MALAWI RP PHILIPPINES UK UNITED KINGDOM MK MACEDONIA RS RUSSIA UP UKRAINE ML MALI RW RWANDA UR USSR RUSSIA MN MONACO SA SAUDI ARABIA US UNITED STATES MO MOROCCO SB ST PIERRE AND UV BURKINA MP MAURITIUS MIQUELON UY URUGUAY MR MAURITANIA SC ST CHRISTOPHER UZ UZBEKISTAN MT MALTA AND NEVIS VC ST VINCENT & THE MU OMAN SE SEYCHELLES GRENADINES MV MALDIVES SF SOUTH AFRICA VE VENEZUELA MW MONTENEGRO SG SENEGAL VI BRITISH VIRGIN MX MEXICO SH ST HELENA ISLANDS MY MALAYSIA SI SLOVENIA VM VIETNAM MZ MOZAMBIQUE SL SIERRA LEONE VT VATICAN CITY NA NETHERLANDS SM SAN MARINO WA NAMIBIA ANTILLES SN SINGAPORE WE WEST BANK NC NEW CALEDONIA SO SOMALIA WF WALLIS FUTUNA NE NIUE SP SPAIN WI WESTERN SAHARA NF NORFOLK ISLAND SR SERBIA WS WESTERN SAMOA NG NIGER ST ST LUCIA WZ SWAZILAND NH VANUATU SU SUDAN YE YEMEN SANAA NI NIGERIA SV SVALBARD YM YEMEN SANAA NL NETHERLANDS SW SWEDEN YO YUGOSLAVIA NO NORWAY SY SYRIA YS YEMEN ADEN NP NEPAL SZ SWITZERLAND ZA ZAMBIA NR NAURA TC UNITED ARAB ZI ZIMBABWE NS SURINAME EMIRATES NQ TRUST TERRITORY NT NETHERLANDS TD TRINIDAD TOBAGO OF THE PACIFIC ANTILLES TE TROMELIN ISLAND ISLANDS: NU NICARAGUA TH THAILAND ZZ NONDISTRIBUTED User's Guide 51 APPENDIX C: Reporting Agency Code and Name 1100 EXECUTIVE OFFICE OF THE 6000 RAILROAD RETIREMENT BOARD PRESIDENT 6100 CONSUMER PRODUCT SAFETY 1145 PEACE CORPS COMMISSION 1152 AGENCY FOR INTERNATIONAL 6300 NATIONAL LABOR RELATIONS DEVELOPMENT BOARD 1200 AGRICULTURE, DEPARTMENT OF 6400 TENNESSEE VALLEY AUTHORITY 1300 COMMERCE, DEPARTMENT OF 6500 FEDERAL MARITIME 1400 INTERIOR, DEPARTMENT OF COMMISSION THE 6700 UNITED STATES INFORMATION 1500 JUSTICE, DEPARTMENT OF AGENCY 1600 LABOR, DEPARTMENT OF 6800 ENVIRONMENTAL PROTECTION 1900 STATE, DEPARTMENT OF AGENCY 2000 TREASURY, DEPARTMENT OF 6900 TRANSPORTATION, DEPARTMENT THE OF 2400 OFFICE OF PERSONNEL 7300 SMALL BUSINESS MANAGEMENT ADMINISTRATION 2700 FEDERAL COMMUNICATIONS 7400 AMERICAN BATTLE MONUMENTS COMMISSION COMMISSION 2900 FEDERAL TRADE COMMISSION 7500 HEALTH AND HUMAN SERVICES, 3000 INTERSTATE COMMERCE DEPARTMENT OF COMMISSION 8000 NATIONAL AERONAUTICS AND 3100 NUCLEAR REGULATORY SPACE ADMINISTRATION COMMISSION 8600 HOUSING AND URBAN 3300 SMITHSONIAN INSTITUTION DEVELOPMENT, DEPARTMENT OF 3355 NATIONAL GALLERY OF ART 8800 NATIONAL ARCHIVES AND 3400 INTERNATIONAL TRADE RECORDS ADMINISTRATION COMMISSION 8900 ENERGY, DEPARTMENT OF 3600 DEPARTMENT OF VETERANS 8961 FEDERAL ENERGY REGULATORY AFFAIRS COMMISSION 4100 MERIT SYSTEMS PROTECTION 9000 SELECTIVE SERVICE SYSTEM BOARD 9100 EDUCATION, DEPARTMENT OF 4200 PENNSYLVANIA AVENUE 9300 FEDERAL MEDIATION AND DEVELOPMENT CORPORATION CONCILIATION SERVICE 4400 ACTION 9400 ARMS CONTROL AND 4500 EQUAL EMPLOYMENT DISARMAMENT AGENCY OPPORTUNITY COMMISSION 9501 BOARD FOR INTERNATIONAL 4700 GENERAL SERVICES BROADCASTING ADMINISTRATION 9502 NATIONAL CAPITAL PLANNING 4900 NATIONAL SCIENCE COMMISSION FOUNDATION 9504 FEDERAL MINE SAFETY AND 5000 SECURITIES AND EXCHANGE HEALTH REVIEW COMMISSION COMMISSION 9506 FEDERAL ELECTION 5400 FEDERAL LABOR RELATIONS COMMISSION AUTHORITY 9507 COMMODITY FUTURES TRADING 5800 FEDERAL EMERGENCY COMMISSION MANAGEMENT AGENCY 9508 NATIONAL TRANSPORTATION 5920 NATIONAL ENDOWMENT FOR THE SAFETY BOARD ARTS 9514 OCCUPATIONAL SAFETY AND 5940 NATIONAL ENDOWMENT FOR THE HEALTH REVIEW COMMISSION HUMANITIES User's Guide 52 9515 ADMINISTRATIVE CONFERENCE 9517 COMMISSION ON CIVIL RIGHTS OF THE U.S. 9524 NATIONAL MEDIATION BOARD 9516 DEFENSE NUCLEAR FACILITIES 9700 DEFENSE, DEPT OF (EXC MIL SAFETY BOARD DEPTS) OFF OF SECRETARY OF DEF User's Guide 53 APPENDIX D: Search Formulas Syntax Syntax @ABS(X) @TRUE Purpose Purpose Return the absolute value of Return boolean true result. X. Syntax Syntax @FALSE @MIN(A, B [,C..N] ) Purpose Purpose Return boolean false result. Return the minimum of two or more paramaters. Syntax @UPCASE(S1 [,S2..SN]) Syntax Purpose @MAX(A, B [,C..N] ) Convert one or more strings to Purpose upper case and concatinate them. Return the maximum of two or more paramaters. Syntax @LOCASE(S1 [,S2..SN] ) Syntax Purpose @AVE(A, B [,C..N] ) Convert one or more strings to Purpose lower case and concatinate them. Return the average of two or more paramaters. Syntax @Pad(S, X [, C] ) Syntax Purpose @INC(X [,N] ) Pad end of string S so that it Purpose is N in length with default Increment X by one or second character or optional third paramater if given. paramater C. Syntax Syntax @DEC(X [,N] ) @LEFTPAD(S, N [,C] ) Purpose Purpose Decrement X by one or by Pad beginning of string S so second paramater if given. that it is N in length with default character or optional Syntax third paramater C. @If(Condition, Result1, Result2) Syntax Purpose @STR(X, P) Return Result1 if Condition is Purpose true or Result2 if Condition is Convert X to a formatted false. string using P as the picture mask. User's Guide 54 Syntax Syntax @NUM(S) @TODAY Purpose Purpose Convert the unformatted string Return the current numeric S to a number. date. Syntax Syntax @LEFTSTR(S, N) @DAY(D) Purpose Purpose Return the first N characters Return the day of the month in of the string S. the date D. Syntax Syntax @RIGHTSTR(S, N) @MONTH(D) Purpose Purpose Return the right N characters Return the month of the year of the string S. in the date D. Syntax Syntax @MIDSTR(S, P, N) @YEAR(D) Purpose Purpose Copy part of the string S Return the year in the date D. starting at position P for N characters. Syntax @TIME(S) Syntax Purpose @INSTR(N, S1, S2) convert the time string S to a Purpose numeric time. Search in S1 for the sub string S2 starting at position Syntax N. @TIMESTR(T) Purpose Syntax Convert the numeric time T to @LENSTR(S) a formatted time string. Purpose Return the length of the Syntax string S. @CURRTIME Purpose Syntax Return the current time. @DATE(S) Purpose Syntax Convert the date string S to a @HOUR(T) numeric date. Purpose See also: 00599Derived Return the hour in the time T. Formulas 00205AddDateFormula Syntax @MINUTE(T) Syntax Purpose @DATESTR(D) Return the number of minutes Purpose in the Time T. Convert the numeric date D to a formatted date string. Syntax @SECOND(T) Purpose User's Guide 55 Return the number of seconds in the time T. Syntax @StateTab(S) Purpose Return the name of a state based on it's two character code or number. Syntax @Country(S) Purpose Return the name of a country based on it's country code. User's Guide 56 INDEX Commerce Business CICAApp, 29 8 Daily, 28 CIFVendorNam), 27 8(a), 25, 30 competition CIFVendorName, 7, Unique source, 29 33 A compressed printing, City, 8, 33, 35 A&E services, 31 12, 13 COAddress1, 27 acquired CompuServe, 1 COName, 8, 34 equipment, 28 Condition, 14 ContEstCode, 7, manufactured, 28 construction, 31 27, 33 supplies, 28 construction site, ContNumb, 25 administration, 27 27 ContOffice, 8, Aladdin, 4 contracts 25, 34 "Alt-M", 12 Termination, 25 ContOfOrNumb, 25 "Alt-O", 14 Count, 13 CountryCode, 8, "Alt-P", 12 Create Computed 27, 35 Always, 12 Fields, 13 CountryManuf, 28 ANSI Basic Printer, customer service, 1 DD350Report, 32 18 DemoTestProg, 31 ASCII File, 18 D DODClaimant, 32 Asian American, 32 Data entry DODSystemCod, 8, Authorized resale, correcting, 26 34 29 deleting, 26 DODSystemNam, 8, AUTOEXEC.BAT, 3 original, 26 34 autoexec.bat, 4 Davis-Bacon Act, 31 Dollars, 26 Average, 13 decision-making, 27 EmergSmBus, 31 Delete Saved Query, ESBSetAside, 31 B 18 EstCompDateM, 31 Basic Ordering Directory EstCompDateY, 31 agreement, 25, 26 Root, 4 EthnicGroup, 32 bidders, 28 Structure, 4 ExtentCompet, 30 Black American, 32 writeable, 4 ForGovContra, 28 Boolean dollars Handicapped, 32 AND, 16 deobligated, 28, ICARParentName, equal to, 16 31 27 greater than, 16 obligated, 28, 31 ICARStatus, 33 less than, 16 Domestic Contractor, ICARVendorName, NOT, 16 30 27 OR, 16 KdContAction, 26 Boolean Logical E LaborStatues, 31 Operators, 16 evaluation ModNumb, 25 Buy Indian/Self- factor, 28 MultiYear, 32 Determination Act, NASAActions, 33 30 F NextHigherSB, 32 Faxing, 1 NumberOffers, 30 C Fieldname NumBidForeig, 28 CD Extensions, 3 ActionDate, 26 Obligation, 26 CICA Address1, 35 PerfCityCode, 27 applicability, 29 Address2, 35 PrdServCode, 7, Clear Current Query, Address3, 35 27, 33 18 AdvAsServAwd, 27 PreferProg, 30 Comma Delimited AuthForComp, 29 PSName, 33 ASCII File, 10 BuyAmerican, 28 User's Guide 57 RollupAgency, 8, hyper-links, 45 O 34 offerors, 28 RptAgency, 25, 34 I OMB, 27 RUAgencyName, 34 ICAR, 8 SBSetAside, 32 indefinite delivery P SICName, 34 contract, 26 Paradox, 10, 18 SICode, 27, 34 Indent Unique, 12 Patent/data rights, SizeOfSmBus, 32 installation 29 StateAbbr, 7, 8, scripts, 4 Picture, 14 27, 33, 35 installing, 3 policy development, SubContPlan, 30 International 27 SynopsisProc, 28 agreement, 29 Print Option, 12 TariffRegula, 28 printer port, 18 TypeContMod, 28 L printer types, 18 Typeof Entry, 26 Labor surplus, 30 processing plant, 27 VendorStreet, 7, Load Query, 17 procurement 33 procedures, 29 VendorType, 30 M Product and Services WomanOwned, 30 management, 27 Manual, 27 ZipCode, 8 management systems, Public Interest, 29 Zipcode, 33, 35 27 FIP Pub. 10-3, 28 manufacturing R Fixed Length ASCII assembly point, 27 records File, 10 Maximum, 13 Found, 17 Foreign Contractor, mined, 28 Read, 17 30 mines, 27 refuse systems, 31 FPDS, 27 Minimum, 13 registration, 1 Function Key regulatory body, 28 Ctrl Page Down, N Rename Query, 18 45 National security, Report Options, 17 Ctrl Page Up, 45 29 Report Query, 9 Esc, 45 national security, 6 report types, 18 F1, 45 network, 3 F10, 45 Never, 12 F2, 45 New definitive F3, 45 contract, 26 F5, 5, 45 New Query, 10 F7, 45 non-nuclear ship F8, 45 repair, 31 Shift-TAB, 45 TAB, 45 G Generate Report / Export, 17 GEnie, 1 gross revenue, 32 Group, 14 grown, 27, 28 H Hispanic American, 32 hospitals, 30 User's Guide 58 S Small Disadvantaged Tie-bid, 30 Save Query, 17 Business, 30 Save Query As, 17 Specify Search U Select Fields, 12 Criteria, 16 Unique, 12 Select File, 14 Specify Sort Select Files, 11 Criteria, 14 V Service Contract Standard Deviation, View Last Counts, 18 Act, 31 13 View Last Report, 18 service rates, 28 sub-totals, 14 Set Key Range, 14 Summation, 13 W Set Printer swap files, 4 Walsh-Healy Act, 31 Type/Port, 18 set-aside, 30 T Sheltered Workshop, Tabular Report, 10 30, 32 Termination for SIC, 8 convenience, 26